﻿CREATE TABLE [Performance].[DiskIO] (
     [DiskIOID] INT           IDENTITY (1, 1) NOT NULL,
	
  
   
  
    [DiskID] INT NULL, 
  
    [AvgDiskSecPerRead] INT NULL, 
    [AvgDiskSecPerWrite] INT NULL, 
    [DiskReadsPerSec] INT NULL, 
    [DiskWritesPerSec] INT NULL, 
  
    [TimeID] INT NULL, 
    [CurrentDiskQueueLength] INT NULL, 
    CONSTRAINT [PK_DiskIOID] PRIMARY KEY CLUSTERED ([DiskIOID] ASC), 
    CONSTRAINT [FK_DiskIO_Disk] FOREIGN KEY ([DiskID]) REFERENCES [Performance].[Disk]([DiskID]),
	  CONSTRAINT [FK_DiskIO_Time] FOREIGN KEY ([TimeID]) REFERENCES [Performance].[Time]([TimeID])
);

